Editing Clustered Index Advanced

Ignore duplicate key values
A warning message will occur when duplicate key values are inserted into a unique index. Only the rows violating the uniqueness constraint will fail.

Recompute statistics
Enable automatic statistics updating.

Allow row locks
Row locks are allowed when accessing the index. The Database Engine determines when row locks are used.

Note: Support from SQL Server 2005 or later.

Allow page locks
Page locks are allowed when accessing the index. The Database Engine determines when page locks are used.

Note: Support from SQL Server 2005 or later.

Create/Rebuild Option

Fill Factor (%)
Specify a percentage that indicates how full the Database Engine should make the leaf level of each index page during index creation or rebuild. Fill Factor must be an integer value from 1 to 100.

Note: SQL Azure does not support.

Pad index
The percentage of free space that is specified by fillfactor is applied to the intermediate-level pages of the index.

Note: Support from SQL Server 2005 or later.

Sort in tempdb
Specify to store temporary sort results in tempdb.

Note: SQL Azure does not support.

Online
Long-term table locks are not held for the duration of the index operation.

Note: Support from SQL Server 2005 or later and SQL Azure.

Max. degree of parallelism
Override the max degree of parallelism configuration option for the duration of the index operation.

Note: Support from SQL Server 2005 or later.